package com.oct.website.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oct.website.entity.Avgthi;
import com.oct.website.entity.Scenic;

public interface ScenicMapper extends BaseMapper<Scenic>{
	
	
	@Select("select scenic_name from oct_iri_website_scenic where MATCH scenic_name AGAINST (#{scenicName} IN NATURAL LANGUAGE MODE) limit 10")
	List<String> selectScenicNameList(String scenicName);
	
	@Select("select count(*) from oct_iri_website_scenic where scenic_name=#{scenicName}")
	int selectScenicNamePrecise(String scenicName);
	
	@Select("select * from oct_iri_website_scenic where scenic_name=#{scenicName}")
	Scenic selectScenic(String scenicName);
	
	
}
